create  table jms_dm.dm_rabbit_person_taking_sed_sum_dt 
(
date_time     date COMMENT '业务日期' ,
user_code     varchar(100) COMMENT '业务员code' ,
user_name     varchar(100) COMMENT '业务员名字' ,
send_sum      bigint COMMENT '发件总量' ,
taking_sum   bigint COMMENT '揽收总量')
ENGINE=OLAP
DUPLICATE KEY(date_time,user_code)
comment '兔兔来了业务员揽收派件量汇总'
PARTITION BY RANGE (date_time) ( 
   START ("2022-09-10") END ("2022-10-09") EVERY (INTERVAL 1 day))
   DISTRIBUTED BY HASH(user_code) BUCKETS 4
PROPERTIES (
"replication_num" = "3",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-365",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "4",
"in_memory" = "false",
"storage_format" = "V2"
);